package com.sto.stoapp.db.constant;
/**
 * 数据字典表
 * @author Administrator
 *
 */
public interface DataDictConstant extends StoBaseConstant {
	public static final String KEY = "key";
	public static final String VALUE = "value";
	public static final String TYPE = "type";
	public static final String BACKUP1 = "backup1";
	/**
	 * 数据字典表名
	 */
	public static final String DATA_DICT_TABLE = "data_dict_table";

	/**
	 * 创建数据字典表
	 */
	public static final String CREATE_DATA_DICT_TABLE = "CREATE TABLE "
			+ " if not exists "
			+ DATA_DICT_TABLE
			+ "("
			+ "id TEXT PRIMARY KEY "
			+ ","
			+ KEY
			+ " text"
			+ ","	
			+ VALUE
			+ " text"
			+ ","
			+STATUS
			+" text "
			+","
			+ TYPE
			+ " text"
			+ ","
			+ BACKUP1
			+ " text"
			+ ","
			+ VERSION
			+ " text"
			+ ","
			+ BACKUPS_ONE
			+ " char(50)"
			+ ","
			+ BACKUPS_TWO
			+ " char(50)"
			+ ","
			+ BACKUPS_THREE + " char(50)" + ")";
	
}
